Setting up a data warehouse connection
This section explains how to set up data warehouse connectivity in a Qlik Compose project.
The data warehouse contains the landing zone tables (the target of the Qlik Replicate task), the logical entities, the actual data warehouse tables and the data mart tables.
For more information on the data warehouse structure in an project Qlik Compose project, see Introduction.
Note that Qlik Compose will not let you add data sources before you add a data warehouse. This is because the server connection settings for the source landing zone are derived from the data warehouse settings.
For all supported data warehouse types, each data warehouse schema (or database if there are no schemas) should be used exclusively for a single data warehouse. In other words, using the same schema for different projects, data warehouses and landing zones is not allowed. Data mart schemas, however, can be shared by different data marts.
For more information on adding data sources, see Setting up Landing Zone and Data Source connections.
For instructions on adding a data warehouse, see the following according to your data warehouse type.